/*
 Navicat Premium Data Transfer

 Source Server         : windows_pc
 Source Server Type    : MySQL
 Source Server Version : 50710
 Source Host           : 192.168.0.20
 Source Database       : db_thinkphp+bjui

 Target Server Type    : MySQL
 Target Server Version : 50710
 File Encoding         : utf-8

 Date: 01/05/2017 16:56:40 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `db_admin`
-- ----------------------------
DROP TABLE IF EXISTS `db_admin`;
CREATE TABLE `db_admin` (
  `userid` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `roleid` smallint(5) DEFAULT '0',
  `encrypt` varchar(6) DEFAULT NULL,
  `lastloginip` varchar(15) DEFAULT NULL,
  `lastlogintime` int(10) unsigned DEFAULT '0',
  `email` varchar(40) DEFAULT NULL,
  `nickname` varchar(50) NOT NULL DEFAULT '',
  `card` varchar(255) DEFAULT NULL,
  `lang` varchar(6) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '开启状态',
  PRIMARY KEY (`userid`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
--  Records of `db_admin`
-- ----------------------------
BEGIN;
INSERT INTO `db_admin` VALUES ('1', 'admin', 'b41199aa5fcb5454ba8a3bc5b03a35a787d3c7cf4dc9602fabce7e1c6cf2b40d', '1', 'EqTKGA', '218.66.116.146', '1483602954', '165490077@qq.com', '超级管理员', '', '', '1'), ('22', 'pdosgk', '77c78e2c3a31b6a55d4f4e90a18ac59b3f582918adee2e5ba84937d75dd773a9', '2', null, '127.0.0.1', '1433993764', null, '1', '', '', '1'), ('26', '!!', '2949fc705e89fa2345a048416afcfe40779268bf9762a60781ef2d14d8efa9c6', '1', null, '127.0.0.1', '1445566153', null, '', '', '', '1');
COMMIT;

-- ----------------------------
--  Table structure for `db_admin_icon`
-- ----------------------------
DROP TABLE IF EXISTS `db_admin_icon`;
CREATE TABLE `db_admin_icon` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `class` varchar(20) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=597 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单图标表';

-- ----------------------------
--  Records of `db_admin_icon`
-- ----------------------------
BEGIN;
INSERT INTO `db_admin_icon` VALUES ('1', 'glass', 'fa-glass', '<i class=\"fa fa-glass\"></i>'), ('2', 'music', 'fa-music', '<i class=\"fa fa-music\"></i>'), ('3', 'search', 'fa-search', '<i class=\"fa fa-search\"></i>'), ('4', 'envelope-o', 'fa-envelope-o', '<i class=\"fa fa-envelope-o\"></i>'), ('5', 'heart', 'fa-heart', '<i class=\"fa fa-heart\"></i>'), ('6', 'star', 'fa-star', '<i class=\"fa fa-star\"></i>'), ('7', 'star-o', 'fa-star-o', '<i class=\"fa fa-star-o\"></i>'), ('8', 'user', 'fa-user', '<i class=\"fa fa-user\"></i>'), ('9', 'film', 'fa-film', '<i class=\"fa fa-film\"></i>'), ('10', 'th-large', 'fa-th-large', '<i class=\"fa fa-th-large\"></i>'), ('11', 'th', 'fa-th', '<i class=\"fa fa-th\"></i>'), ('12', 'th-list', 'fa-th-list', '<i class=\"fa fa-th-list\"></i>'), ('13', 'check', 'fa-check', '<i class=\"fa fa-check\"></i>'), ('14', 'times', 'fa-times', '<i class=\"fa fa-times\"></i>'), ('15', 'search-plus', 'fa-search-plus', '<i class=\"fa fa-search-plus\"></i>'), ('16', 'search-minus', 'fa-search-minus', '<i class=\"fa fa-search-minus\"></i>'), ('17', 'power-off', 'fa-power-off', '<i class=\"fa fa-power-off\"></i>'), ('18', 'signal', 'fa-signal', '<i class=\"fa fa-signal\"></i>'), ('19', 'cog', 'fa-cog', '<i class=\"fa fa-cog\"></i>'), ('20', 'trash-o', 'fa-trash-o', '<i class=\"fa fa-trash-o\"></i>'), ('21', 'home', 'fa-home', '<i class=\"fa fa-home\"></i>'), ('22', 'file-o', 'fa-file-o', '<i class=\"fa fa-file-o\"></i>'), ('23', 'clock-o', 'fa-clock-o', '<i class=\"fa fa-clock-o\"></i>'), ('24', 'road', 'fa-road', '<i class=\"fa fa-road\"></i>'), ('25', 'download', 'fa-download', '<i class=\"fa fa-download\"></i>'), ('26', 'arrow-circle-o-down', 'fa-arrow-circle-o-do', '<i class=\"fa fa-arrow-circle-o-down\"></i>'), ('27', 'arrow-circle-o-up', 'fa-arrow-circle-o-up', '<i class=\"fa fa-arrow-circle-o-up\"></i>'), ('28', 'inbox', 'fa-inbox', '<i class=\"fa fa-inbox\"></i>'), ('29', 'play-circle-o', 'fa-play-circle-o', '<i class=\"fa fa-play-circle-o\"></i>'), ('30', 'repeat', 'fa-repeat', '<i class=\"fa fa-repeat\"></i>'), ('31', 'refresh', 'fa-refresh', '<i class=\"fa fa-refresh\"></i>'), ('32', 'list-alt', 'fa-list-alt', '<i class=\"fa fa-list-alt\"></i>'), ('33', 'lock', 'fa-lock', '<i class=\"fa fa-lock\"></i>'), ('34', 'flag', 'fa-flag', '<i class=\"fa fa-flag\"></i>'), ('35', 'headphones', 'fa-headphones', '<i class=\"fa fa-headphones\"></i>'), ('36', 'volume-off', 'fa-volume-off', '<i class=\"fa fa-volume-off\"></i>'), ('37', 'volume-down', 'fa-volume-down', '<i class=\"fa fa-volume-down\"></i>'), ('38', 'volume-up', 'fa-volume-up', '<i class=\"fa fa-volume-up\"></i>'), ('39', 'qrcode', 'fa-qrcode', '<i class=\"fa fa-qrcode\"></i>'), ('40', 'barcode', 'fa-barcode', '<i class=\"fa fa-barcode\"></i>'), ('41', 'tag', 'fa-tag', '<i class=\"fa fa-tag\"></i>'), ('42', 'tags', 'fa-tags', '<i class=\"fa fa-tags\"></i>'), ('43', 'book', 'fa-book', '<i class=\"fa fa-book\"></i>'), ('44', 'bookmark', 'fa-bookmark', '<i class=\"fa fa-bookmark\"></i>'), ('45', 'print', 'fa-print', '<i class=\"fa fa-print\"></i>'), ('46', 'camera', 'fa-camera', '<i class=\"fa fa-camera\"></i>'), ('47', 'font', 'fa-font', '<i class=\"fa fa-font\"></i>'), ('48', 'bold', 'fa-bold', '<i class=\"fa fa-bold\"></i>'), ('49', 'italic', 'fa-italic', '<i class=\"fa fa-italic\"></i>'), ('50', 'text-height', 'fa-text-height', '<i class=\"fa fa-text-height\"></i>'), ('51', 'text-width', 'fa-text-width', '<i class=\"fa fa-text-width\"></i>'), ('52', 'align-left', 'fa-align-left', '<i class=\"fa fa-align-left\"></i>'), ('53', 'align-center', 'fa-align-center', '<i class=\"fa fa-align-center\"></i>'), ('54', 'align-right', 'fa-align-right', '<i class=\"fa fa-align-right\"></i>'), ('55', 'align-justify', 'fa-align-justify', '<i class=\"fa fa-align-justify\"></i>'), ('56', 'list', 'fa-list', '<i class=\"fa fa-list\"></i>'), ('57', 'outdent', 'fa-outdent', '<i class=\"fa fa-outdent\"></i>'), ('58', 'indent', 'fa-indent', '<i class=\"fa fa-indent\"></i>'), ('59', 'video-camera', 'fa-video-camera', '<i class=\"fa fa-video-camera\"></i>'), ('60', 'picture-o', 'fa-picture-o', '<i class=\"fa fa-picture-o\"></i>'), ('61', 'pencil', 'fa-pencil', '<i class=\"fa fa-pencil\"></i>'), ('62', 'map-marker', 'fa-map-marker', '<i class=\"fa fa-map-marker\"></i>'), ('63', 'adjust', 'fa-adjust', '<i class=\"fa fa-adjust\"></i>'), ('64', 'tint', 'fa-tint', '<i class=\"fa fa-tint\"></i>'), ('65', 'pencil-square-o', 'fa-pencil-square-o', '<i class=\"fa fa-pencil-square-o\"></i>'), ('66', 'share-square-o', 'fa-share-square-o', '<i class=\"fa fa-share-square-o\"></i>'), ('67', 'check-square-o', 'fa-check-square-o', '<i class=\"fa fa-check-square-o\"></i>'), ('68', 'arrows', 'fa-arrows', '<i class=\"fa fa-arrows\"></i>'), ('69', 'step-backward', 'fa-step-backward', '<i class=\"fa fa-step-backward\"></i>'), ('70', 'fast-backward', 'fa-fast-backward', '<i class=\"fa fa-fast-backward\"></i>'), ('71', 'backward', 'fa-backward', '<i class=\"fa fa-backward\"></i>'), ('72', 'play', 'fa-play', '<i class=\"fa fa-play\"></i>'), ('73', 'pause', 'fa-pause', '<i class=\"fa fa-pause\"></i>'), ('74', 'stop', 'fa-stop', '<i class=\"fa fa-stop\"></i>'), ('75', 'forward', 'fa-forward', '<i class=\"fa fa-forward\"></i>'), ('76', 'fast-forward', 'fa-fast-forward', '<i class=\"fa fa-fast-forward\"></i>'), ('77', 'step-forward', 'fa-step-forward', '<i class=\"fa fa-step-forward\"></i>'), ('78', 'eject', 'fa-eject', '<i class=\"fa fa-eject\"></i>'), ('79', 'chevron-left', 'fa-chevron-left', '<i class=\"fa fa-chevron-left\"></i>'), ('80', 'chevron-right', 'fa-chevron-right', '<i class=\"fa fa-chevron-right\"></i>'), ('81', 'plus-circle', 'fa-plus-circle', '<i class=\"fa fa-plus-circle\"></i>'), ('82', 'minus-circle', 'fa-minus-circle', '<i class=\"fa fa-minus-circle\"></i>'), ('83', 'times-circle', 'fa-times-circle', '<i class=\"fa fa-times-circle\"></i>'), ('84', 'check-circle', 'fa-check-circle', '<i class=\"fa fa-check-circle\"></i>'), ('85', 'question-circle', 'fa-question-circle', '<i class=\"fa fa-question-circle\"></i>'), ('86', 'info-circle', 'fa-info-circle', '<i class=\"fa fa-info-circle\"></i>'), ('87', 'crosshairs', 'fa-crosshairs', '<i class=\"fa fa-crosshairs\"></i>'), ('88', 'times-circle-o', 'fa-times-circle-o', '<i class=\"fa fa-times-circle-o\"></i>'), ('89', 'check-circle-o', 'fa-check-circle-o', '<i class=\"fa fa-check-circle-o\"></i>'), ('90', 'ban', 'fa-ban', '<i class=\"fa fa-ban\"></i>'), ('91', 'arrow-left', 'fa-arrow-left', '<i class=\"fa fa-arrow-left\"></i>'), ('92', 'arrow-right', 'fa-arrow-right', '<i class=\"fa fa-arrow-right\"></i>'), ('93', 'arrow-up', 'fa-arrow-up', '<i class=\"fa fa-arrow-up\"></i>'), ('94', 'arrow-down', 'fa-arrow-down', '<i class=\"fa fa-arrow-down\"></i>'), ('95', 'share', 'fa-share', '<i class=\"fa fa-share\"></i>'), ('96', 'expand', 'fa-expand', '<i class=\"fa fa-expand\"></i>'), ('97', 'compress', 'fa-compress', '<i class=\"fa fa-compress\"></i>'), ('98', 'plus', 'fa-plus', '<i class=\"fa fa-plus\"></i>'), ('99', 'minus', 'fa-minus', '<i class=\"fa fa-minus\"></i>'), ('100', 'asterisk', 'fa-asterisk', '<i class=\"fa fa-asterisk\"></i>'), ('101', 'exclamation-circle', 'fa-exclamation-circl', '<i class=\"fa fa-exclamation-circle\"></i>'), ('102', 'gift', 'fa-gift', '<i class=\"fa fa-gift\"></i>'), ('103', 'leaf', 'fa-leaf', '<i class=\"fa fa-leaf\"></i>'), ('104', 'fire', 'fa-fire', '<i class=\"fa fa-fire\"></i>'), ('105', 'eye', 'fa-eye', '<i class=\"fa fa-eye\"></i>'), ('106', 'eye-slash', 'fa-eye-slash', '<i class=\"fa fa-eye-slash\"></i>'), ('107', 'exclamation-triangle', 'fa-exclamation-trian', '<i class=\"fa fa-exclamation-triangle\"></i>'), ('108', 'plane', 'fa-plane', '<i class=\"fa fa-plane\"></i>'), ('109', 'calendar', 'fa-calendar', '<i class=\"fa fa-calendar\"></i>'), ('110', 'random', 'fa-random', '<i class=\"fa fa-random\"></i>'), ('111', 'comment', 'fa-comment', '<i class=\"fa fa-comment\"></i>'), ('112', 'magnet', 'fa-magnet', '<i class=\"fa fa-magnet\"></i>'), ('113', 'chevron-up', 'fa-chevron-up', '<i class=\"fa fa-chevron-up\"></i>'), ('114', 'chevron-down', 'fa-chevron-down', '<i class=\"fa fa-chevron-down\"></i>'), ('115', 'retweet', 'fa-retweet', '<i class=\"fa fa-retweet\"></i>'), ('116', 'shopping-cart', 'fa-shopping-cart', '<i class=\"fa fa-shopping-cart\"></i>'), ('117', 'folder', 'fa-folder', '<i class=\"fa fa-folder\"></i>'), ('118', 'folder-open', 'fa-folder-open', '<i class=\"fa fa-folder-open\"></i>'), ('119', 'arrows-v', 'fa-arrows-v', '<i class=\"fa fa-arrows-v\"></i>'), ('120', 'arrows-h', 'fa-arrows-h', '<i class=\"fa fa-arrows-h\"></i>'), ('121', 'bar-chart', 'fa-bar-chart', '<i class=\"fa fa-bar-chart\"></i>'), ('122', 'twitter-square', 'fa-twitter-square', '<i class=\"fa fa-twitter-square\"></i>'), ('123', 'facebook-square', 'fa-facebook-square', '<i class=\"fa fa-facebook-square\"></i>'), ('124', 'camera-retro', 'fa-camera-retro', '<i class=\"fa fa-camera-retro\"></i>'), ('125', 'key', 'fa-key', '<i class=\"fa fa-key\"></i>'), ('126', 'cogs', 'fa-cogs', '<i class=\"fa fa-cogs\"></i>'), ('127', 'comments', 'fa-comments', '<i class=\"fa fa-comments\"></i>'), ('128', 'thumbs-o-up', 'fa-thumbs-o-up', '<i class=\"fa fa-thumbs-o-up\"></i>'), ('129', 'thumbs-o-down', 'fa-thumbs-o-down', '<i class=\"fa fa-thumbs-o-down\"></i>'), ('130', 'star-half', 'fa-star-half', '<i class=\"fa fa-star-half\"></i>'), ('131', 'heart-o', 'fa-heart-o', '<i class=\"fa fa-heart-o\"></i>'), ('132', 'sign-out', 'fa-sign-out', '<i class=\"fa fa-sign-out\"></i>'), ('133', 'linkedin-square', 'fa-linkedin-square', '<i class=\"fa fa-linkedin-square\"></i>'), ('134', 'thumb-tack', 'fa-thumb-tack', '<i class=\"fa fa-thumb-tack\"></i>'), ('135', 'external-link', 'fa-external-link', '<i class=\"fa fa-external-link\"></i>'), ('136', 'sign-in', 'fa-sign-in', '<i class=\"fa fa-sign-in\"></i>'), ('137', 'trophy', 'fa-trophy', '<i class=\"fa fa-trophy\"></i>'), ('138', 'github-square', 'fa-github-square', '<i class=\"fa fa-github-square\"></i>'), ('139', 'upload', 'fa-upload', '<i class=\"fa fa-upload\"></i>'), ('140', 'lemon-o', 'fa-lemon-o', '<i class=\"fa fa-lemon-o\"></i>'), ('141', 'phone', 'fa-phone', '<i class=\"fa fa-phone\"></i>'), ('142', 'square-o', 'fa-square-o', '<i class=\"fa fa-square-o\"></i>'), ('143', 'bookmark-o', 'fa-bookmark-o', '<i class=\"fa fa-bookmark-o\"></i>'), ('144', 'phone-square', 'fa-phone-square', '<i class=\"fa fa-phone-square\"></i>'), ('145', 'twitter', 'fa-twitter', '<i class=\"fa fa-twitter\"></i>'), ('146', 'facebook', 'fa-facebook', '<i class=\"fa fa-facebook\"></i>'), ('147', 'github', 'fa-github', '<i class=\"fa fa-github\"></i>'), ('148', 'unlock', 'fa-unlock', '<i class=\"fa fa-unlock\"></i>'), ('149', 'credit-card', 'fa-credit-card', '<i class=\"fa fa-credit-card\"></i>'), ('150', 'rss', 'fa-rss', '<i class=\"fa fa-rss\"></i>'), ('151', 'hdd-o', 'fa-hdd-o', '<i class=\"fa fa-hdd-o\"></i>'), ('152', 'bullhorn', 'fa-bullhorn', '<i class=\"fa fa-bullhorn\"></i>'), ('153', 'bell', 'fa-bell', '<i class=\"fa fa-bell\"></i>'), ('154', 'certificate', 'fa-certificate', '<i class=\"fa fa-certificate\"></i>'), ('155', 'hand-o-right', 'fa-hand-o-right', '<i class=\"fa fa-hand-o-right\"></i>'), ('156', 'hand-o-left', 'fa-hand-o-left', '<i class=\"fa fa-hand-o-left\"></i>'), ('157', 'hand-o-up', 'fa-hand-o-up', '<i class=\"fa fa-hand-o-up\"></i>'), ('158', 'hand-o-down', 'fa-hand-o-down', '<i class=\"fa fa-hand-o-down\"></i>'), ('159', 'arrow-circle-left', 'fa-arrow-circle-left', '<i class=\"fa fa-arrow-circle-left\"></i>'), ('160', 'arrow-circle-right', 'fa-arrow-circle-righ', '<i class=\"fa fa-arrow-circle-right\"></i>'), ('161', 'arrow-circle-up', 'fa-arrow-circle-up', '<i class=\"fa fa-arrow-circle-up\"></i>'), ('162', 'arrow-circle-down', 'fa-arrow-circle-down', '<i class=\"fa fa-arrow-circle-down\"></i>'), ('163', 'globe', 'fa-globe', '<i class=\"fa fa-globe\"></i>'), ('164', 'wrench', 'fa-wrench', '<i class=\"fa fa-wrench\"></i>'), ('165', 'tasks', 'fa-tasks', '<i class=\"fa fa-tasks\"></i>'), ('166', 'filter', 'fa-filter', '<i class=\"fa fa-filter\"></i>'), ('167', 'briefcase', 'fa-briefcase', '<i class=\"fa fa-briefcase\"></i>'), ('168', 'arrows-alt', 'fa-arrows-alt', '<i class=\"fa fa-arrows-alt\"></i>'), ('169', 'users', 'fa-users', '<i class=\"fa fa-users\"></i>'), ('170', 'link', 'fa-link', '<i class=\"fa fa-link\"></i>'), ('171', 'cloud', 'fa-cloud', '<i class=\"fa fa-cloud\"></i>'), ('172', 'flask', 'fa-flask', '<i class=\"fa fa-flask\"></i>'), ('173', 'scissors', 'fa-scissors', '<i class=\"fa fa-scissors\"></i>'), ('174', 'files-o', 'fa-files-o', '<i class=\"fa fa-files-o\"></i>'), ('175', 'paperclip', 'fa-paperclip', '<i class=\"fa fa-paperclip\"></i>'), ('176', 'floppy-o', 'fa-floppy-o', '<i class=\"fa fa-floppy-o\"></i>'), ('177', 'square', 'fa-square', '<i class=\"fa fa-square\"></i>'), ('178', 'bars', 'fa-bars', '<i class=\"fa fa-bars\"></i>'), ('179', 'list-ul', 'fa-list-ul', '<i class=\"fa fa-list-ul\"></i>'), ('180', 'list-ol', 'fa-list-ol', '<i class=\"fa fa-list-ol\"></i>'), ('181', 'strikethrough', 'fa-strikethrough', '<i class=\"fa fa-strikethrough\"></i>'), ('182', 'underline', 'fa-underline', '<i class=\"fa fa-underline\"></i>'), ('183', 'table', 'fa-table', '<i class=\"fa fa-table\"></i>'), ('184', 'magic', 'fa-magic', '<i class=\"fa fa-magic\"></i>'), ('185', 'truck', 'fa-truck', '<i class=\"fa fa-truck\"></i>'), ('186', 'pinterest', 'fa-pinterest', '<i class=\"fa fa-pinterest\"></i>'), ('187', 'pinterest-square', 'fa-pinterest-square', '<i class=\"fa fa-pinterest-square\"></i>'), ('188', 'google-plus-square', 'fa-google-plus-squar', '<i class=\"fa fa-google-plus-square\"></i>'), ('189', 'google-plus', 'fa-google-plus', '<i class=\"fa fa-google-plus\"></i>'), ('190', 'money', 'fa-money', '<i class=\"fa fa-money\"></i>'), ('191', 'caret-down', 'fa-caret-down', '<i class=\"fa fa-caret-down\"></i>'), ('192', 'caret-up', 'fa-caret-up', '<i class=\"fa fa-caret-up\"></i>'), ('193', 'caret-left', 'fa-caret-left', '<i class=\"fa fa-caret-left\"></i>'), ('194', 'caret-right', 'fa-caret-right', '<i class=\"fa fa-caret-right\"></i>'), ('195', 'columns', 'fa-columns', '<i class=\"fa fa-columns\"></i>'), ('196', 'sort', 'fa-sort', '<i class=\"fa fa-sort\"></i>'), ('197', 'sort-desc', 'fa-sort-desc', '<i class=\"fa fa-sort-desc\"></i>'), ('198', 'sort-asc', 'fa-sort-asc', '<i class=\"fa fa-sort-asc\"></i>'), ('199', 'envelope', 'fa-envelope', '<i class=\"fa fa-envelope\"></i>'), ('200', 'linkedin', 'fa-linkedin', '<i class=\"fa fa-linkedin\"></i>'), ('201', 'undo', 'fa-undo', '<i class=\"fa fa-undo\"></i>'), ('202', 'gavel', 'fa-gavel', '<i class=\"fa fa-gavel\"></i>'), ('203', 'tachometer', 'fa-tachometer', '<i class=\"fa fa-tachometer\"></i>'), ('204', 'comment-o', 'fa-comment-o', '<i class=\"fa fa-comment-o\"></i>'), ('205', 'comments-o', 'fa-comments-o', '<i class=\"fa fa-comments-o\"></i>'), ('206', 'bolt', 'fa-bolt', '<i class=\"fa fa-bolt\"></i>'), ('207', 'sitemap', 'fa-sitemap', '<i class=\"fa fa-sitemap\"></i>'), ('208', 'umbrella', 'fa-umbrella', '<i class=\"fa fa-umbrella\"></i>'), ('209', 'clipboard', 'fa-clipboard', '<i class=\"fa fa-clipboard\"></i>'), ('210', 'lightbulb-o', 'fa-lightbulb-o', '<i class=\"fa fa-lightbulb-o\"></i>'), ('211', 'exchange', 'fa-exchange', '<i class=\"fa fa-exchange\"></i>'), ('212', 'cloud-download', 'fa-cloud-download', '<i class=\"fa fa-cloud-download\"></i>'), ('213', 'cloud-upload', 'fa-cloud-upload', '<i class=\"fa fa-cloud-upload\"></i>'), ('214', 'user-md', 'fa-user-md', '<i class=\"fa fa-user-md\"></i>'), ('215', 'stethoscope', 'fa-stethoscope', '<i class=\"fa fa-stethoscope\"></i>'), ('216', 'suitcase', 'fa-suitcase', '<i class=\"fa fa-suitcase\"></i>'), ('217', 'bell-o', 'fa-bell-o', '<i class=\"fa fa-bell-o\"></i>'), ('218', 'coffee', 'fa-coffee', '<i class=\"fa fa-coffee\"></i>'), ('219', 'cutlery', 'fa-cutlery', '<i class=\"fa fa-cutlery\"></i>'), ('220', 'file-text-o', 'fa-file-text-o', '<i class=\"fa fa-file-text-o\"></i>'), ('221', 'building-o', 'fa-building-o', '<i class=\"fa fa-building-o\"></i>'), ('222', 'hospital-o', 'fa-hospital-o', '<i class=\"fa fa-hospital-o\"></i>'), ('223', 'ambulance', 'fa-ambulance', '<i class=\"fa fa-ambulance\"></i>'), ('224', 'medkit', 'fa-medkit', '<i class=\"fa fa-medkit\"></i>'), ('225', 'fighter-jet', 'fa-fighter-jet', '<i class=\"fa fa-fighter-jet\"></i>'), ('226', 'beer', 'fa-beer', '<i class=\"fa fa-beer\"></i>'), ('227', 'h-square', 'fa-h-square', '<i class=\"fa fa-h-square\"></i>'), ('228', 'plus-square', 'fa-plus-square', '<i class=\"fa fa-plus-square\"></i>'), ('229', 'angle-double-left', 'fa-angle-double-left', '<i class=\"fa fa-angle-double-left\"></i>'), ('230', 'angle-double-right', 'fa-angle-double-righ', '<i class=\"fa fa-angle-double-right\"></i>'), ('231', 'angle-double-up', 'fa-angle-double-up', '<i class=\"fa fa-angle-double-up\"></i>'), ('232', 'angle-double-down', 'fa-angle-double-down', '<i class=\"fa fa-angle-double-down\"></i>'), ('233', 'angle-left', 'fa-angle-left', '<i class=\"fa fa-angle-left\"></i>'), ('234', 'angle-right', 'fa-angle-right', '<i class=\"fa fa-angle-right\"></i>'), ('235', 'angle-up', 'fa-angle-up', '<i class=\"fa fa-angle-up\"></i>'), ('236', 'angle-down', 'fa-angle-down', '<i class=\"fa fa-angle-down\"></i>'), ('237', 'desktop', 'fa-desktop', '<i class=\"fa fa-desktop\"></i>'), ('238', 'laptop', 'fa-laptop', '<i class=\"fa fa-laptop\"></i>'), ('239', 'tablet', 'fa-tablet', '<i class=\"fa fa-tablet\"></i>'), ('240', 'mobile', 'fa-mobile', '<i class=\"fa fa-mobile\"></i>'), ('241', 'circle-o', 'fa-circle-o', '<i class=\"fa fa-circle-o\"></i>'), ('242', 'quote-left', 'fa-quote-left', '<i class=\"fa fa-quote-left\"></i>'), ('243', 'quote-right', 'fa-quote-right', '<i class=\"fa fa-quote-right\"></i>'), ('244', 'spinner', 'fa-spinner', '<i class=\"fa fa-spinner\"></i>'), ('245', 'circle', 'fa-circle', '<i class=\"fa fa-circle\"></i>'), ('246', 'reply', 'fa-reply', '<i class=\"fa fa-reply\"></i>'), ('247', 'github-alt', 'fa-github-alt', '<i class=\"fa fa-github-alt\"></i>'), ('248', 'folder-o', 'fa-folder-o', '<i class=\"fa fa-folder-o\"></i>'), ('249', 'folder-open-o', 'fa-folder-open-o', '<i class=\"fa fa-folder-open-o\"></i>'), ('250', 'smile-o', 'fa-smile-o', '<i class=\"fa fa-smile-o\"></i>'), ('251', 'frown-o', 'fa-frown-o', '<i class=\"fa fa-frown-o\"></i>'), ('252', 'meh-o', 'fa-meh-o', '<i class=\"fa fa-meh-o\"></i>'), ('253', 'gamepad', 'fa-gamepad', '<i class=\"fa fa-gamepad\"></i>'), ('254', 'keyboard-o', 'fa-keyboard-o', '<i class=\"fa fa-keyboard-o\"></i>'), ('255', 'flag-o', 'fa-flag-o', '<i class=\"fa fa-flag-o\"></i>'), ('256', 'flag-checkered', 'fa-flag-checkered', '<i class=\"fa fa-flag-checkered\"></i>'), ('257', 'terminal', 'fa-terminal', '<i class=\"fa fa-terminal\"></i>'), ('258', 'code', 'fa-code', '<i class=\"fa fa-code\"></i>'), ('259', 'reply-all', 'fa-reply-all', '<i class=\"fa fa-reply-all\"></i>'), ('260', 'star-half-o', 'fa-star-half-o', '<i class=\"fa fa-star-half-o\"></i>'), ('261', 'location-arrow', 'fa-location-arrow', '<i class=\"fa fa-location-arrow\"></i>'), ('262', 'crop', 'fa-crop', '<i class=\"fa fa-crop\"></i>'), ('263', 'code-fork', 'fa-code-fork', '<i class=\"fa fa-code-fork\"></i>'), ('264', 'chain-broken', 'fa-chain-broken', '<i class=\"fa fa-chain-broken\"></i>'), ('265', 'question', 'fa-question', '<i class=\"fa fa-question\"></i>'), ('266', 'info', 'fa-info', '<i class=\"fa fa-info\"></i>'), ('267', 'exclamation', 'fa-exclamation', '<i class=\"fa fa-exclamation\"></i>'), ('268', 'superscript', 'fa-superscript', '<i class=\"fa fa-superscript\"></i>'), ('269', 'subscript', 'fa-subscript', '<i class=\"fa fa-subscript\"></i>'), ('270', 'eraser', 'fa-eraser', '<i class=\"fa fa-eraser\"></i>'), ('271', 'puzzle-piece', 'fa-puzzle-piece', '<i class=\"fa fa-puzzle-piece\"></i>'), ('272', 'microphone', 'fa-microphone', '<i class=\"fa fa-microphone\"></i>'), ('273', 'microphone-slash', 'fa-microphone-slash', '<i class=\"fa fa-microphone-slash\"></i>'), ('274', 'shield', 'fa-shield', '<i class=\"fa fa-shield\"></i>'), ('275', 'calendar-o', 'fa-calendar-o', '<i class=\"fa fa-calendar-o\"></i>'), ('276', 'fire-extinguisher', 'fa-fire-extinguisher', '<i class=\"fa fa-fire-extinguisher\"></i>'), ('277', 'rocket', 'fa-rocket', '<i class=\"fa fa-rocket\"></i>'), ('278', 'maxcdn', 'fa-maxcdn', '<i class=\"fa fa-maxcdn\"></i>'), ('279', 'chevron-circle-left', 'fa-chevron-circle-le', '<i class=\"fa fa-chevron-circle-left\"></i>'), ('280', 'chevron-circle-right', 'fa-chevron-circle-ri', '<i class=\"fa fa-chevron-circle-right\"></i>'), ('281', 'chevron-circle-up', 'fa-chevron-circle-up', '<i class=\"fa fa-chevron-circle-up\"></i>'), ('282', 'chevron-circle-down', 'fa-chevron-circle-do', '<i class=\"fa fa-chevron-circle-down\"></i>'), ('283', 'html5', 'fa-html5', '<i class=\"fa fa-html5\"></i>'), ('284', 'css3', 'fa-css3', '<i class=\"fa fa-css3\"></i>'), ('285', 'anchor', 'fa-anchor', '<i class=\"fa fa-anchor\"></i>'), ('286', 'unlock-alt', 'fa-unlock-alt', '<i class=\"fa fa-unlock-alt\"></i>'), ('287', 'bullseye', 'fa-bullseye', '<i class=\"fa fa-bullseye\"></i>'), ('288', 'ellipsis-h', 'fa-ellipsis-h', '<i class=\"fa fa-ellipsis-h\"></i>'), ('289', 'ellipsis-v', 'fa-ellipsis-v', '<i class=\"fa fa-ellipsis-v\"></i>'), ('290', 'rss-square', 'fa-rss-square', '<i class=\"fa fa-rss-square\"></i>'), ('291', 'play-circle', 'fa-play-circle', '<i class=\"fa fa-play-circle\"></i>'), ('292', 'ticket', 'fa-ticket', '<i class=\"fa fa-ticket\"></i>'), ('293', 'minus-square', 'fa-minus-square', '<i class=\"fa fa-minus-square\"></i>'), ('294', 'minus-square-o', 'fa-minus-square-o', '<i class=\"fa fa-minus-square-o\"></i>'), ('295', 'level-up', 'fa-level-up', '<i class=\"fa fa-level-up\"></i>'), ('296', 'level-down', 'fa-level-down', '<i class=\"fa fa-level-down\"></i>'), ('297', 'check-square', 'fa-check-square', '<i class=\"fa fa-check-square\"></i>'), ('298', 'pencil-square', 'fa-pencil-square', '<i class=\"fa fa-pencil-square\"></i>'), ('299', 'external-link-square', 'fa-external-link-squ', '<i class=\"fa fa-external-link-square\"></i>'), ('300', 'share-square', 'fa-share-square', '<i class=\"fa fa-share-square\"></i>'), ('301', 'compass', 'fa-compass', '<i class=\"fa fa-compass\"></i>'), ('302', 'caret-square-o-down', 'fa-caret-square-o-do', '<i class=\"fa fa-caret-square-o-down\"></i>'), ('303', 'caret-square-o-up', 'fa-caret-square-o-up', '<i class=\"fa fa-caret-square-o-up\"></i>'), ('304', 'caret-square-o-right', 'fa-caret-square-o-ri', '<i class=\"fa fa-caret-square-o-right\"></i>'), ('305', 'eur', 'fa-eur', '<i class=\"fa fa-eur\"></i>'), ('306', 'gbp', 'fa-gbp', '<i class=\"fa fa-gbp\"></i>'), ('307', 'usd', 'fa-usd', '<i class=\"fa fa-usd\"></i>'), ('308', 'inr', 'fa-inr', '<i class=\"fa fa-inr\"></i>'), ('309', 'jpy', 'fa-jpy', '<i class=\"fa fa-jpy\"></i>'), ('310', 'rub', 'fa-rub', '<i class=\"fa fa-rub\"></i>'), ('311', 'krw', 'fa-krw', '<i class=\"fa fa-krw\"></i>'), ('312', 'btc', 'fa-btc', '<i class=\"fa fa-btc\"></i>'), ('313', 'file', 'fa-file', '<i class=\"fa fa-file\"></i>'), ('314', 'file-text', 'fa-file-text', '<i class=\"fa fa-file-text\"></i>'), ('315', 'sort-alpha-asc', 'fa-sort-alpha-asc', '<i class=\"fa fa-sort-alpha-asc\"></i>'), ('316', 'sort-alpha-desc', 'fa-sort-alpha-desc', '<i class=\"fa fa-sort-alpha-desc\"></i>'), ('317', 'sort-amount-asc', 'fa-sort-amount-asc', '<i class=\"fa fa-sort-amount-asc\"></i>'), ('318', 'sort-amount-desc', 'fa-sort-amount-desc', '<i class=\"fa fa-sort-amount-desc\"></i>'), ('319', 'sort-numeric-asc', 'fa-sort-numeric-asc', '<i class=\"fa fa-sort-numeric-asc\"></i>'), ('320', 'sort-numeric-desc', 'fa-sort-numeric-desc', '<i class=\"fa fa-sort-numeric-desc\"></i>'), ('321', 'thumbs-up', 'fa-thumbs-up', '<i class=\"fa fa-thumbs-up\"></i>'), ('322', 'thumbs-down', 'fa-thumbs-down', '<i class=\"fa fa-thumbs-down\"></i>'), ('323', 'youtube-square', 'fa-youtube-square', '<i class=\"fa fa-youtube-square\"></i>'), ('324', 'youtube', 'fa-youtube', '<i class=\"fa fa-youtube\"></i>'), ('325', 'xing', 'fa-xing', '<i class=\"fa fa-xing\"></i>'), ('326', 'xing-square', 'fa-xing-square', '<i class=\"fa fa-xing-square\"></i>'), ('327', 'youtube-play', 'fa-youtube-play', '<i class=\"fa fa-youtube-play\"></i>'), ('328', 'dropbox', 'fa-dropbox', '<i class=\"fa fa-dropbox\"></i>'), ('329', 'stack-overflow', 'fa-stack-overflow', '<i class=\"fa fa-stack-overflow\"></i>'), ('330', 'instagram', 'fa-instagram', '<i class=\"fa fa-instagram\"></i>'), ('331', 'flickr', 'fa-flickr', '<i class=\"fa fa-flickr\"></i>'), ('332', 'adn', 'fa-adn', '<i class=\"fa fa-adn\"></i>'), ('333', 'bitbucket', 'fa-bitbucket', '<i class=\"fa fa-bitbucket\"></i>'), ('334', 'bitbucket-square', 'fa-bitbucket-square', '<i class=\"fa fa-bitbucket-square\"></i>'), ('335', 'tumblr', 'fa-tumblr', '<i class=\"fa fa-tumblr\"></i>'), ('336', 'tumblr-square', 'fa-tumblr-square', '<i class=\"fa fa-tumblr-square\"></i>'), ('337', 'long-arrow-down', 'fa-long-arrow-down', '<i class=\"fa fa-long-arrow-down\"></i>'), ('338', 'long-arrow-up', 'fa-long-arrow-up', '<i class=\"fa fa-long-arrow-up\"></i>'), ('339', 'long-arrow-left', 'fa-long-arrow-left', '<i class=\"fa fa-long-arrow-left\"></i>'), ('340', 'long-arrow-right', 'fa-long-arrow-right', '<i class=\"fa fa-long-arrow-right\"></i>'), ('341', 'apple', 'fa-apple', '<i class=\"fa fa-apple\"></i>'), ('342', 'windows', 'fa-windows', '<i class=\"fa fa-windows\"></i>'), ('343', 'android', 'fa-android', '<i class=\"fa fa-android\"></i>'), ('344', 'linux', 'fa-linux', '<i class=\"fa fa-linux\"></i>'), ('345', 'dribbble', 'fa-dribbble', '<i class=\"fa fa-dribbble\"></i>'), ('346', 'skype', 'fa-skype', '<i class=\"fa fa-skype\"></i>'), ('347', 'foursquare', 'fa-foursquare', '<i class=\"fa fa-foursquare\"></i>'), ('348', 'trello', 'fa-trello', '<i class=\"fa fa-trello\"></i>'), ('349', 'female', 'fa-female', '<i class=\"fa fa-female\"></i>'), ('350', 'male', 'fa-male', '<i class=\"fa fa-male\"></i>'), ('351', 'gratipay', 'fa-gratipay', '<i class=\"fa fa-gratipay\"></i>'), ('352', 'sun-o', 'fa-sun-o', '<i class=\"fa fa-sun-o\"></i>'), ('353', 'moon-o', 'fa-moon-o', '<i class=\"fa fa-moon-o\"></i>'), ('354', 'archive', 'fa-archive', '<i class=\"fa fa-archive\"></i>'), ('355', 'bug', 'fa-bug', '<i class=\"fa fa-bug\"></i>'), ('356', 'vk', 'fa-vk', '<i class=\"fa fa-vk\"></i>'), ('357', 'weibo', 'fa-weibo', '<i class=\"fa fa-weibo\"></i>'), ('358', 'renren', 'fa-renren', '<i class=\"fa fa-renren\"></i>'), ('359', 'pagelines', 'fa-pagelines', '<i class=\"fa fa-pagelines\"></i>'), ('360', 'stack-exchange', 'fa-stack-exchange', '<i class=\"fa fa-stack-exchange\"></i>'), ('361', 'arrow-circle-o-right', 'fa-arrow-circle-o-ri', '<i class=\"fa fa-arrow-circle-o-right\"></i>'), ('362', 'arrow-circle-o-left', 'fa-arrow-circle-o-le', '<i class=\"fa fa-arrow-circle-o-left\"></i>'), ('363', 'caret-square-o-left', 'fa-caret-square-o-le', '<i class=\"fa fa-caret-square-o-left\"></i>'), ('364', 'dot-circle-o', 'fa-dot-circle-o', '<i class=\"fa fa-dot-circle-o\"></i>'), ('365', 'wheelchair', 'fa-wheelchair', '<i class=\"fa fa-wheelchair\"></i>'), ('366', 'vimeo-square', 'fa-vimeo-square', '<i class=\"fa fa-vimeo-square\"></i>'), ('367', 'try', 'fa-try', '<i class=\"fa fa-try\"></i>'), ('368', 'plus-square-o', 'fa-plus-square-o', '<i class=\"fa fa-plus-square-o\"></i>'), ('369', 'space-shuttle', 'fa-space-shuttle', '<i class=\"fa fa-space-shuttle\"></i>'), ('370', 'slack', 'fa-slack', '<i class=\"fa fa-slack\"></i>'), ('371', 'envelope-square', 'fa-envelope-square', '<i class=\"fa fa-envelope-square\"></i>'), ('372', 'wordpress', 'fa-wordpress', '<i class=\"fa fa-wordpress\"></i>'), ('373', 'openid', 'fa-openid', '<i class=\"fa fa-openid\"></i>'), ('374', 'university', 'fa-university', '<i class=\"fa fa-university\"></i>'), ('375', 'graduation-cap', 'fa-graduation-cap', '<i class=\"fa fa-graduation-cap\"></i>'), ('376', 'yahoo', 'fa-yahoo', '<i class=\"fa fa-yahoo\"></i>'), ('377', 'google', 'fa-google', '<i class=\"fa fa-google\"></i>'), ('378', 'reddit', 'fa-reddit', '<i class=\"fa fa-reddit\"></i>'), ('379', 'reddit-square', 'fa-reddit-square', '<i class=\"fa fa-reddit-square\"></i>'), ('380', 'stumbleupon-circle', 'fa-stumbleupon-circl', '<i class=\"fa fa-stumbleupon-circle\"></i>'), ('381', 'stumbleupon', 'fa-stumbleupon', '<i class=\"fa fa-stumbleupon\"></i>'), ('382', 'delicious', 'fa-delicious', '<i class=\"fa fa-delicious\"></i>'), ('383', 'digg', 'fa-digg', '<i class=\"fa fa-digg\"></i>'), ('384', 'pied-piper', 'fa-pied-piper', '<i class=\"fa fa-pied-piper\"></i>'), ('385', 'pied-piper-alt', 'fa-pied-piper-alt', '<i class=\"fa fa-pied-piper-alt\"></i>'), ('386', 'drupal', 'fa-drupal', '<i class=\"fa fa-drupal\"></i>'), ('387', 'joomla', 'fa-joomla', '<i class=\"fa fa-joomla\"></i>'), ('388', 'language', 'fa-language', '<i class=\"fa fa-language\"></i>'), ('389', 'fax', 'fa-fax', '<i class=\"fa fa-fax\"></i>'), ('390', 'building', 'fa-building', '<i class=\"fa fa-building\"></i>'), ('391', 'child', 'fa-child', '<i class=\"fa fa-child\"></i>'), ('392', 'paw', 'fa-paw', '<i class=\"fa fa-paw\"></i>'), ('393', 'spoon', 'fa-spoon', '<i class=\"fa fa-spoon\"></i>'), ('394', 'cube', 'fa-cube', '<i class=\"fa fa-cube\"></i>'), ('395', 'cubes', 'fa-cubes', '<i class=\"fa fa-cubes\"></i>'), ('396', 'behance', 'fa-behance', '<i class=\"fa fa-behance\"></i>'), ('397', 'behance-square', 'fa-behance-square', '<i class=\"fa fa-behance-square\"></i>'), ('398', 'steam', 'fa-steam', '<i class=\"fa fa-steam\"></i>'), ('399', 'steam-square', 'fa-steam-square', '<i class=\"fa fa-steam-square\"></i>'), ('400', 'recycle', 'fa-recycle', '<i class=\"fa fa-recycle\"></i>'), ('401', 'car', 'fa-car', '<i class=\"fa fa-car\"></i>'), ('402', 'taxi', 'fa-taxi', '<i class=\"fa fa-taxi\"></i>'), ('403', 'tree', 'fa-tree', '<i class=\"fa fa-tree\"></i>'), ('404', 'spotify', 'fa-spotify', '<i class=\"fa fa-spotify\"></i>'), ('405', 'deviantart', 'fa-deviantart', '<i class=\"fa fa-deviantart\"></i>'), ('406', 'soundcloud', 'fa-soundcloud', '<i class=\"fa fa-soundcloud\"></i>'), ('407', 'database', 'fa-database', '<i class=\"fa fa-database\"></i>'), ('408', 'file-pdf-o', 'fa-file-pdf-o', '<i class=\"fa fa-file-pdf-o\"></i>'), ('409', 'file-word-o', 'fa-file-word-o', '<i class=\"fa fa-file-word-o\"></i>'), ('410', 'file-excel-o', 'fa-file-excel-o', '<i class=\"fa fa-file-excel-o\"></i>'), ('411', 'file-powerpoint-o', 'fa-file-powerpoint-o', '<i class=\"fa fa-file-powerpoint-o\"></i>'), ('412', 'file-image-o', 'fa-file-image-o', '<i class=\"fa fa-file-image-o\"></i>'), ('413', 'file-archive-o', 'fa-file-archive-o', '<i class=\"fa fa-file-archive-o\"></i>'), ('414', 'file-audio-o', 'fa-file-audio-o', '<i class=\"fa fa-file-audio-o\"></i>'), ('415', 'file-video-o', 'fa-file-video-o', '<i class=\"fa fa-file-video-o\"></i>'), ('416', 'file-code-o', 'fa-file-code-o', '<i class=\"fa fa-file-code-o\"></i>'), ('417', 'vine', 'fa-vine', '<i class=\"fa fa-vine\"></i>'), ('418', 'codepen', 'fa-codepen', '<i class=\"fa fa-codepen\"></i>'), ('419', 'jsfiddle', 'fa-jsfiddle', '<i class=\"fa fa-jsfiddle\"></i>'), ('420', 'life-ring', 'fa-life-ring', '<i class=\"fa fa-life-ring\"></i>'), ('421', 'circle-o-notch', 'fa-circle-o-notch', '<i class=\"fa fa-circle-o-notch\"></i>'), ('422', 'rebel', 'fa-rebel', '<i class=\"fa fa-rebel\"></i>'), ('423', 'empire', 'fa-empire', '<i class=\"fa fa-empire\"></i>'), ('424', 'git-square', 'fa-git-square', '<i class=\"fa fa-git-square\"></i>'), ('425', 'git', 'fa-git', '<i class=\"fa fa-git\"></i>'), ('426', 'hacker-news', 'fa-hacker-news', '<i class=\"fa fa-hacker-news\"></i>'), ('427', 'tencent-weibo', 'fa-tencent-weibo', '<i class=\"fa fa-tencent-weibo\"></i>'), ('428', 'qq', 'fa-qq', '<i class=\"fa fa-qq\"></i>'), ('429', 'weixin', 'fa-weixin', '<i class=\"fa fa-weixin\"></i>'), ('430', 'paper-plane', 'fa-paper-plane', '<i class=\"fa fa-paper-plane\"></i>'), ('431', 'paper-plane-o', 'fa-paper-plane-o', '<i class=\"fa fa-paper-plane-o\"></i>'), ('432', 'history', 'fa-history', '<i class=\"fa fa-history\"></i>'), ('433', 'circle-thin', 'fa-circle-thin', '<i class=\"fa fa-circle-thin\"></i>'), ('434', 'header', 'fa-header', '<i class=\"fa fa-header\"></i>'), ('435', 'paragraph', 'fa-paragraph', '<i class=\"fa fa-paragraph\"></i>'), ('436', 'sliders', 'fa-sliders', '<i class=\"fa fa-sliders\"></i>'), ('437', 'share-alt', 'fa-share-alt', '<i class=\"fa fa-share-alt\"></i>'), ('438', 'share-alt-square', 'fa-share-alt-square', '<i class=\"fa fa-share-alt-square\"></i>'), ('439', 'bomb', 'fa-bomb', '<i class=\"fa fa-bomb\"></i>'), ('440', 'futbol-o', 'fa-futbol-o', '<i class=\"fa fa-futbol-o\"></i>'), ('441', 'tty', 'fa-tty', '<i class=\"fa fa-tty\"></i>'), ('442', 'binoculars', 'fa-binoculars', '<i class=\"fa fa-binoculars\"></i>'), ('443', 'plug', 'fa-plug', '<i class=\"fa fa-plug\"></i>'), ('444', 'slideshare', 'fa-slideshare', '<i class=\"fa fa-slideshare\"></i>'), ('445', 'twitch', 'fa-twitch', '<i class=\"fa fa-twitch\"></i>'), ('446', 'yelp', 'fa-yelp', '<i class=\"fa fa-yelp\"></i>'), ('447', 'newspaper-o', 'fa-newspaper-o', '<i class=\"fa fa-newspaper-o\"></i>'), ('448', 'wifi', 'fa-wifi', '<i class=\"fa fa-wifi\"></i>'), ('449', 'calculator', 'fa-calculator', '<i class=\"fa fa-calculator\"></i>'), ('450', 'paypal', 'fa-paypal', '<i class=\"fa fa-paypal\"></i>'), ('451', 'google-wallet', 'fa-google-wallet', '<i class=\"fa fa-google-wallet\"></i>'), ('452', 'cc-visa', 'fa-cc-visa', '<i class=\"fa fa-cc-visa\"></i>'), ('453', 'cc-mastercard', 'fa-cc-mastercard', '<i class=\"fa fa-cc-mastercard\"></i>'), ('454', 'cc-discover', 'fa-cc-discover', '<i class=\"fa fa-cc-discover\"></i>'), ('455', 'cc-amex', 'fa-cc-amex', '<i class=\"fa fa-cc-amex\"></i>'), ('456', 'cc-paypal', 'fa-cc-paypal', '<i class=\"fa fa-cc-paypal\"></i>'), ('457', 'cc-stripe', 'fa-cc-stripe', '<i class=\"fa fa-cc-stripe\"></i>'), ('458', 'bell-slash', 'fa-bell-slash', '<i class=\"fa fa-bell-slash\"></i>'), ('459', 'bell-slash-o', 'fa-bell-slash-o', '<i class=\"fa fa-bell-slash-o\"></i>'), ('460', 'trash', 'fa-trash', '<i class=\"fa fa-trash\"></i>'), ('461', 'copyright', 'fa-copyright', '<i class=\"fa fa-copyright\"></i>'), ('462', 'at', 'fa-at', '<i class=\"fa fa-at\"></i>'), ('463', 'eyedropper', 'fa-eyedropper', '<i class=\"fa fa-eyedropper\"></i>'), ('464', 'paint-brush', 'fa-paint-brush', '<i class=\"fa fa-paint-brush\"></i>'), ('465', 'birthday-cake', 'fa-birthday-cake', '<i class=\"fa fa-birthday-cake\"></i>'), ('466', 'area-chart', 'fa-area-chart', '<i class=\"fa fa-area-chart\"></i>'), ('467', 'pie-chart', 'fa-pie-chart', '<i class=\"fa fa-pie-chart\"></i>'), ('468', 'line-chart', 'fa-line-chart', '<i class=\"fa fa-line-chart\"></i>'), ('469', 'lastfm', 'fa-lastfm', '<i class=\"fa fa-lastfm\"></i>'), ('470', 'lastfm-square', 'fa-lastfm-square', '<i class=\"fa fa-lastfm-square\"></i>'), ('471', 'toggle-off', 'fa-toggle-off', '<i class=\"fa fa-toggle-off\"></i>'), ('472', 'toggle-on', 'fa-toggle-on', '<i class=\"fa fa-toggle-on\"></i>'), ('473', 'bicycle', 'fa-bicycle', '<i class=\"fa fa-bicycle\"></i>'), ('474', 'bus', 'fa-bus', '<i class=\"fa fa-bus\"></i>'), ('475', 'ioxhost', 'fa-ioxhost', '<i class=\"fa fa-ioxhost\"></i>'), ('476', 'angellist', 'fa-angellist', '<i class=\"fa fa-angellist\"></i>'), ('477', 'cc', 'fa-cc', '<i class=\"fa fa-cc\"></i>'), ('478', 'ils', 'fa-ils', '<i class=\"fa fa-ils\"></i>'), ('479', 'meanpath', 'fa-meanpath', '<i class=\"fa fa-meanpath\"></i>'), ('480', 'buysellads', 'fa-buysellads', '<i class=\"fa fa-buysellads\"></i>'), ('481', 'connectdevelop', 'fa-connectdevelop', '<i class=\"fa fa-connectdevelop\"></i>'), ('482', 'dashcube', 'fa-dashcube', '<i class=\"fa fa-dashcube\"></i>'), ('483', 'forumbee', 'fa-forumbee', '<i class=\"fa fa-forumbee\"></i>'), ('484', 'leanpub', 'fa-leanpub', '<i class=\"fa fa-leanpub\"></i>'), ('485', 'sellsy', 'fa-sellsy', '<i class=\"fa fa-sellsy\"></i>'), ('486', 'shirtsinbulk', 'fa-shirtsinbulk', '<i class=\"fa fa-shirtsinbulk\"></i>'), ('487', 'simplybuilt', 'fa-simplybuilt', '<i class=\"fa fa-simplybuilt\"></i>'), ('488', 'skyatlas', 'fa-skyatlas', '<i class=\"fa fa-skyatlas\"></i>'), ('489', 'cart-plus', 'fa-cart-plus', '<i class=\"fa fa-cart-plus\"></i>'), ('490', 'cart-arrow-down', 'fa-cart-arrow-down', '<i class=\"fa fa-cart-arrow-down\"></i>'), ('491', 'diamond', 'fa-diamond', '<i class=\"fa fa-diamond\"></i>'), ('492', 'ship', 'fa-ship', '<i class=\"fa fa-ship\"></i>'), ('493', 'user-secret', 'fa-user-secret', '<i class=\"fa fa-user-secret\"></i>'), ('494', 'motorcycle', 'fa-motorcycle', '<i class=\"fa fa-motorcycle\"></i>'), ('495', 'street-view', 'fa-street-view', '<i class=\"fa fa-street-view\"></i>'), ('496', 'heartbeat', 'fa-heartbeat', '<i class=\"fa fa-heartbeat\"></i>'), ('497', 'venus', 'fa-venus', '<i class=\"fa fa-venus\"></i>'), ('498', 'mars', 'fa-mars', '<i class=\"fa fa-mars\"></i>'), ('499', 'mercury', 'fa-mercury', '<i class=\"fa fa-mercury\"></i>'), ('500', 'transgender', 'fa-transgender', '<i class=\"fa fa-transgender\"></i>'), ('501', 'transgender-alt', 'fa-transgender-alt', '<i class=\"fa fa-transgender-alt\"></i>'), ('502', 'venus-double', 'fa-venus-double', '<i class=\"fa fa-venus-double\"></i>'), ('503', 'mars-double', 'fa-mars-double', '<i class=\"fa fa-mars-double\"></i>'), ('504', 'venus-mars', 'fa-venus-mars', '<i class=\"fa fa-venus-mars\"></i>'), ('505', 'mars-stroke', 'fa-mars-stroke', '<i class=\"fa fa-mars-stroke\"></i>'), ('506', 'mars-stroke-v', 'fa-mars-stroke-v', '<i class=\"fa fa-mars-stroke-v\"></i>'), ('507', 'mars-stroke-h', 'fa-mars-stroke-h', '<i class=\"fa fa-mars-stroke-h\"></i>'), ('508', 'neuter', 'fa-neuter', '<i class=\"fa fa-neuter\"></i>'), ('509', 'facebook-official', 'fa-facebook-official', '<i class=\"fa fa-facebook-official\"></i>'), ('510', 'pinterest-p', 'fa-pinterest-p', '<i class=\"fa fa-pinterest-p\"></i>'), ('511', 'whatsapp', 'fa-whatsapp', '<i class=\"fa fa-whatsapp\"></i>'), ('512', 'server', 'fa-server', '<i class=\"fa fa-server\"></i>'), ('513', 'user-plus', 'fa-user-plus', '<i class=\"fa fa-user-plus\"></i>'), ('514', 'user-times', 'fa-user-times', '<i class=\"fa fa-user-times\"></i>'), ('515', 'bed', 'fa-bed', '<i class=\"fa fa-bed\"></i>'), ('516', 'viacoin', 'fa-viacoin', '<i class=\"fa fa-viacoin\"></i>'), ('517', 'train', 'fa-train', '<i class=\"fa fa-train\"></i>'), ('518', 'subway', 'fa-subway', '<i class=\"fa fa-subway\"></i>'), ('519', 'medium', 'fa-medium', '<i class=\"fa fa-medium\"></i>'), ('520', 'warning margin-right', 'fa-warning margin-ri', '<i class=\"fa fa-warning margin-right-sm\"></i>'), ('521', 'exclamation-circle m', 'fa-exclamation-circl', '<i class=\"fa fa-exclamation-circle margin-right-sm\"></i>'), ('522', 'hotel', 'fa-hotel', '<i class=\"fa fa-hotel\"></i>'), ('523', 'automobile', 'fa-automobile', '<i class=\"fa fa-automobile\"></i>'), ('524', 'bank', 'fa-bank', '<i class=\"fa fa-bank\"></i>'), ('525', 'bar-chart-o', 'fa-bar-chart-o', '<i class=\"fa fa-bar-chart-o\"></i>'), ('526', 'cab', 'fa-cab', '<i class=\"fa fa-cab\"></i>'), ('527', 'close', 'fa-close', '<i class=\"fa fa-close\"></i>'), ('528', 'dashboard', 'fa-dashboard', '<i class=\"fa fa-dashboard\"></i>'), ('529', 'edit', 'fa-edit', '<i class=\"fa fa-edit\"></i>'), ('530', 'file-movie-o', 'fa-file-movie-o', '<i class=\"fa fa-file-movie-o\"></i>'), ('531', 'file-photo-o', 'fa-file-photo-o', '<i class=\"fa fa-file-photo-o\"></i>'), ('532', 'file-picture-o', 'fa-file-picture-o', '<i class=\"fa fa-file-picture-o\"></i>'), ('533', 'file-sound-o', 'fa-file-sound-o', '<i class=\"fa fa-file-sound-o\"></i>'), ('534', 'file-zip-o', 'fa-file-zip-o', '<i class=\"fa fa-file-zip-o\"></i>'), ('535', 'flash', 'fa-flash', '<i class=\"fa fa-flash\"></i>'), ('536', 'gear', 'fa-gear', '<i class=\"fa fa-gear\"></i>'), ('537', 'gears', 'fa-gears', '<i class=\"fa fa-gears\"></i>'), ('538', 'genderless', 'fa-genderless', '<i class=\"fa fa-genderless\"></i>'), ('539', 'group', 'fa-group', '<i class=\"fa fa-group\"></i>'), ('540', 'image', 'fa-image', '<i class=\"fa fa-image\"></i>'), ('541', 'institution', 'fa-institution', '<i class=\"fa fa-institution\"></i>'), ('542', 'legal', 'fa-legal', '<i class=\"fa fa-legal\"></i>'), ('543', 'life-bouy', 'fa-life-bouy', '<i class=\"fa fa-life-bouy\"></i>'), ('544', 'life-buoy', 'fa-life-buoy', '<i class=\"fa fa-life-buoy\"></i>'), ('545', 'life-saver', 'fa-life-saver', '<i class=\"fa fa-life-saver\"></i>'), ('546', 'mail-forward', 'fa-mail-forward', '<i class=\"fa fa-mail-forward\"></i>'), ('547', 'mail-reply', 'fa-mail-reply', '<i class=\"fa fa-mail-reply\"></i>'), ('548', 'mail-reply-all', 'fa-mail-reply-all', '<i class=\"fa fa-mail-reply-all\"></i>'), ('549', 'mobile-phone', 'fa-mobile-phone', '<i class=\"fa fa-mobile-phone\"></i>'), ('550', 'mortar-board', 'fa-mortar-board', '<i class=\"fa fa-mortar-board\"></i>'), ('551', 'navicon', 'fa-navicon', '<i class=\"fa fa-navicon\"></i>'), ('552', 'photo', 'fa-photo', '<i class=\"fa fa-photo\"></i>'), ('553', 'remove', 'fa-remove', '<i class=\"fa fa-remove\"></i>'), ('554', 'reorder', 'fa-reorder', '<i class=\"fa fa-reorder\"></i>'), ('555', 'send', 'fa-send', '<i class=\"fa fa-send\"></i>'), ('556', 'send-o', 'fa-send-o', '<i class=\"fa fa-send-o\"></i>'), ('557', 'soccer-ball-o', 'fa-soccer-ball-o', '<i class=\"fa fa-soccer-ball-o\"></i>'), ('558', 'sort-down', 'fa-sort-down', '<i class=\"fa fa-sort-down\"></i>'), ('559', 'sort-up', 'fa-sort-up', '<i class=\"fa fa-sort-up\"></i>'), ('560', 'star-half-empty', 'fa-star-half-empty', '<i class=\"fa fa-star-half-empty\"></i>'), ('561', 'star-half-full', 'fa-star-half-full', '<i class=\"fa fa-star-half-full\"></i>'), ('562', 'support', 'fa-support', '<i class=\"fa fa-support\"></i>'), ('563', 'toggle-down', 'fa-toggle-down', '<i class=\"fa fa-toggle-down\"></i>'), ('564', 'toggle-left', 'fa-toggle-left', '<i class=\"fa fa-toggle-left\"></i>'), ('565', 'toggle-right', 'fa-toggle-right', '<i class=\"fa fa-toggle-right\"></i>'), ('566', 'toggle-up', 'fa-toggle-up', '<i class=\"fa fa-toggle-up\"></i>'), ('567', 'unsorted', 'fa-unsorted', '<i class=\"fa fa-unsorted\"></i>'), ('568', 'warning', 'fa-warning', '<i class=\"fa fa-warning\"></i>'), ('569', 'info-circle fa-lg fa', 'fa-info-circle fa-lg', '<i class=\"fa fa-info-circle fa-lg fa-li\"></i>'), ('570', 'bitcoin', 'fa-bitcoin', '<i class=\"fa fa-bitcoin\"></i>'), ('571', 'cny', 'fa-cny', '<i class=\"fa fa-cny\"></i>'), ('572', 'dollar', 'fa-dollar', '<i class=\"fa fa-dollar\"></i>'), ('573', 'euro', 'fa-euro', '<i class=\"fa fa-euro\"></i>'), ('574', 'rmb', 'fa-rmb', '<i class=\"fa fa-rmb\"></i>'), ('575', 'rouble', 'fa-rouble', '<i class=\"fa fa-rouble\"></i>'), ('576', 'ruble', 'fa-ruble', '<i class=\"fa fa-ruble\"></i>'), ('577', 'rupee', 'fa-rupee', '<i class=\"fa fa-rupee\"></i>'), ('578', 'shekel', 'fa-shekel', '<i class=\"fa fa-shekel\"></i>'), ('579', 'sheqel', 'fa-sheqel', '<i class=\"fa fa-sheqel\"></i>'), ('580', 'turkish-lira', 'fa-turkish-lira', '<i class=\"fa fa-turkish-lira\"></i>'), ('581', 'won', 'fa-won', '<i class=\"fa fa-won\"></i>'), ('582', 'yen', 'fa-yen', '<i class=\"fa fa-yen\"></i>'), ('583', 'chain', 'fa-chain', '<i class=\"fa fa-chain\"></i>'), ('584', 'copy', 'fa-copy', '<i class=\"fa fa-copy\"></i>'), ('585', 'cut', 'fa-cut', '<i class=\"fa fa-cut\"></i>'), ('586', 'dedent', 'fa-dedent', '<i class=\"fa fa-dedent\"></i>'), ('587', 'paste', 'fa-paste', '<i class=\"fa fa-paste\"></i>'), ('588', 'rotate-left', 'fa-rotate-left', '<i class=\"fa fa-rotate-left\"></i>'), ('589', 'rotate-right', 'fa-rotate-right', '<i class=\"fa fa-rotate-right\"></i>'), ('590', 'save', 'fa-save', '<i class=\"fa fa-save\"></i>'), ('591', 'unlink', 'fa-unlink', '<i class=\"fa fa-unlink\"></i>'), ('592', 'facebook-f', 'fa-facebook-f', '<i class=\"fa fa-facebook-f\"></i>'), ('593', 'ge', 'fa-ge', '<i class=\"fa fa-ge\"></i>'), ('594', 'gittip', 'fa-gittip', '<i class=\"fa fa-gittip\"></i>'), ('595', 'ra', 'fa-ra', '<i class=\"fa fa-ra\"></i>'), ('596', 'wechat', 'fa-wechat', '<i class=\"fa fa-wechat\"></i>');
COMMIT;

-- ----------------------------
--  Table structure for `db_admin_menu`
-- ----------------------------
DROP TABLE IF EXISTS `db_admin_menu`;
CREATE TABLE `db_admin_menu` (
  `id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(40) NOT NULL DEFAULT '' COMMENT '菜单名',
  `icon` varchar(20) DEFAULT NULL COMMENT '图标',
  `parentid` smallint(6) NOT NULL DEFAULT '0',
  `remark` varchar(100) DEFAULT NULL COMMENT '菜单描述',
  `m` char(20) NOT NULL DEFAULT '',
  `c` char(20) NOT NULL DEFAULT '' COMMENT 'Class名',
  `a` char(20) NOT NULL DEFAULT '' COMMENT 'Action名',
  `data` char(100) NOT NULL DEFAULT '',
  `listorder` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `display` enum('1','0') NOT NULL DEFAULT '1',
  `project1` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `project2` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `project3` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `project4` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `project5` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `listorder` (`listorder`),
  KEY `parentid` (`parentid`),
  KEY `module` (`m`,`c`,`a`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单表';

-- ----------------------------
--  Records of `db_admin_menu`
-- ----------------------------
BEGIN;
INSERT INTO `db_admin_menu` VALUES ('1', '文章管理', 'book', '0', '文章管理', 'Admin', 'Article', '', '', '50', '1', '1', '1', '1', '1', '1'), ('3', '系统设置', '', '0', '系统设置', 'Admin', 'System', '', '', '100', '1', '1', '1', '1', '1', '1'), ('4', '管理员设置', 'user-md', '3', '系统设置-管理员设置', 'Admin', 'System', '', '', '0', '1', '1', '1', '1', '1', '1'), ('5', '菜单设置', 'list-ol', '3', '系统设置-菜单设置', 'Admin', 'System', '', '', '0', '1', '1', '1', '1', '1', '1'), ('30', '添加角色', null, '7', '系统设置-管理员设置-角色列表-添加角色', 'Admin', 'System', 'adminRoleAdd', '', '0', '0', '1', '1', '1', '1', '1'), ('7', '角色列表', null, '4', '系统设置-管理员设置-角色列表', 'Admin', 'System', 'adminRoleList', '', '20', '1', '1', '1', '1', '1', '1'), ('8', '菜单列表', '', '5', '系统设置-菜单设置-菜单列表', 'Admin', 'System', 'adminNodeLists', '', '0', '1', '1', '1', '1', '1', '1'), ('9', '内容管理', null, '37', '文章管理-文章管理-内容管理', 'Admin', 'Article', 'index', '', '0', '1', '1', '1', '1', '1', '1'), ('11', '栏目管理', null, '37', '文章管理-文章管理-栏目管理', 'Admin', 'Article', 'category', '', '0', '1', '1', '1', '1', '1', '1'), ('15', '修改菜单', null, '8', '系统设置-菜单设置-菜单列表-修改菜单', 'Admin', 'Syetem', 'adminNodeEdit', '', '0', '0', '1', '1', '1', '1', '1'), ('16', '删除菜单', null, '8', '系统设置-菜单设置-菜单列表-删除菜单', 'Admin', 'System', 'adminNodeDelete', '', '0', '0', '1', '1', '1', '1', '1'), ('14', '添加菜单', null, '8', '系统设置-菜单设置-菜单列表-添加菜单', 'Admin', 'System', 'adminNodeAdd', '', '0', '0', '1', '1', '1', '1', '1'), ('17', '管理员管理', 'th-large', '4', '系统设置-管理员设置-管理员管理', 'Admin', 'System', 'adminManage', '', '10', '1', '1', '1', '1', '1', '1'), ('18', '选择栏目', '', '9', '文章管理-文章管理-内容管理-选择栏目', 'Admin', 'Article', 'manage', '', '0', '0', '1', '1', '1', '1', '1'), ('22', '添加栏目', '', '11', '文章管理-文章管理-栏目管理-添加栏目', 'Admin', 'Article', 'CategoryAdd', '', '0', '0', '1', '1', '1', '1', '1'), ('23', '编辑栏目', null, '11', '文章管理-文章管理-栏目管理-编辑栏目', 'Admin', 'Article', 'CategoryEdit', '', '0', '0', '1', '1', '1', '1', '1'), ('24', '删除栏目', null, '11', '文章管理-文章管理-栏目管理-删除栏目', 'Admin', 'Article', 'CategoryDelete', '', '0', '0', '1', '1', '1', '1', '1'), ('25', '更新栏目缓存', null, '11', '文章管理-文章管理-栏目管理-更新栏目缓存', 'Admin', 'Article', 'CategoryCache', '', '0', '0', '1', '1', '1', '1', '1'), ('26', '添加管理员', null, '17', '系统设置-管理员设置-管理员管理-添加管理员', 'Admin', 'System', 'adminAdd', '', '0', '0', '1', '1', '1', '1', '1'), ('27', '修改管理员', null, '17', '系统设置-管理员设置-管理员管理-修改管理员', 'Admin', 'System', 'adminEdit', '', '0', '0', '1', '1', '1', '1', '1'), ('28', '重置密码', null, '17', '系统设置-管理员设置-管理员管理-重置密码', 'Admin', 'System', 'adminResetPassword', '', '0', '0', '1', '1', '1', '1', '1'), ('29', '删除管理员', null, '17', '系统设置-管理员设置-管理员管理-删除管理员', 'Admin', 'System', 'adminDelete', '', '0', '0', '1', '1', '1', '1', '1'), ('31', '禁用角色', null, '7', '系统设置-管理员设置-角色列表-禁用角色', 'Admin', 'System', 'adminRoleForbid', '', '0', '0', '1', '1', '1', '1', '1'), ('32', '权限设置', null, '7', '系统设置-管理员设置-角色列表-权限设置', 'Admin', 'System', 'adminPrivSetting', '', '0', '0', '1', '1', '1', '1', '1'), ('33', '修改角色', null, '7', '系统设置-管理员设置-角色列表-修改角色', 'Admin', 'System', 'adminRoleEdit', '', '0', '0', '1', '1', '1', '1', '1'), ('34', '删除角色', null, '7', '系统设置-管理员设置-角色列表-删除角色', 'Admin', 'System', 'adminRoleDelete', '', '0', '0', '1', '1', '1', '1', '1'), ('37', '文章管理', 'book', '1', '文章管理-文章管理', 'Admin', 'Article', '', '', '0', '1', '1', '1', '1', '1', '1'), ('40', '邮件管理', 'video-camera', '0', null, 'Admin', 'Email', '', '', '60', '1', '1', '1', '1', '1', '1'), ('41', '邮件管理', 'envelope-o', '40', null, 'Admin', 'Email', '', '', '0', '1', '1', '1', '1', '1', '1'), ('42', '邮件测试', '', '41', null, 'Admin', 'Email', 'index', '', '0', '1', '1', '1', '1', '1', '1'), ('46', '小说管理', 'star-o', '0', null, 'Admin', 'Book', '', '', '0', '0', '1', '1', '1', '1', '1'), ('47', '小说管理', '', '46', null, 'Admin', 'manage', '', '', '0', '0', '1', '1', '1', '1', '1'), ('48', '小说列表', '', '47', null, 'Admin', 'Book', 'manage', '', '0', '1', '1', '1', '1', '1', '1'), ('50', '菜单列表(新)', '', '5', null, 'Admin', 'System', 'adminNodeListsNew', '', '0', '1', '1', '1', '1', '1', '1'), ('80', '产品列表', '', '79', null, 'Admin', 'Product', 'index', '', '0', '1', '1', '1', '1', '1', '1'), ('79', '产品管理', '', '78', null, 'Admin', 'Product', '', '', '0', '1', '1', '1', '1', '1', '1'), ('78', '产品管理', '', '0', null, 'Admin', 'Product', '', '', '0', '0', '1', '1', '1', '1', '1'), ('81', '新增菜单', null, '48', null, 'Admin', 'Book', '', '', '0', '1', '1', '1', '1', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `db_admin_role`
-- ----------------------------
DROP TABLE IF EXISTS `db_admin_role`;
CREATE TABLE `db_admin_role` (
  `roleid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `rolename` varchar(20) NOT NULL DEFAULT '',
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`roleid`),
  KEY `pid` (`pid`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台角色表';

-- ----------------------------
--  Records of `db_admin_role`
-- ----------------------------
BEGIN;
INSERT INTO `db_admin_role` VALUES ('1', '超级管理员', '0', '1', ''), ('2', '编辑人员', '0', '0', '网站编辑人员方法');
COMMIT;

-- ----------------------------
--  Table structure for `db_admin_role_priv`
-- ----------------------------
DROP TABLE IF EXISTS `db_admin_role_priv`;
CREATE TABLE `db_admin_role_priv` (
  `roleid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `menuid` int(5) DEFAULT NULL,
  `m` char(20) NOT NULL,
  `c` char(20) NOT NULL,
  `a` char(20) NOT NULL,
  `data` char(30) NOT NULL DEFAULT '',
  KEY `roleid` (`roleid`,`m`,`c`,`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='用户组权限';

-- ----------------------------
--  Records of `db_admin_role_priv`
-- ----------------------------
BEGIN;
INSERT INTO `db_admin_role_priv` VALUES ('2', '9', 'admin', 'article', 'index', ''), ('2', '37', 'admin', 'article', '', ''), ('2', '1', 'admin', 'article', '', ''), ('2', '80', 'admin', 'product', 'index', ''), ('2', '79', 'admin', 'product', '', ''), ('2', '78', 'admin', 'product', '', ''), ('2', '81', 'admin', 'book', '', ''), ('2', '48', 'admin', 'book', 'manage', ''), ('2', '47', 'admin', 'manage', '', ''), ('2', '46', 'admin', 'book', '', ''), ('2', '18', 'admin', 'article', 'manage', ''), ('2', '11', 'admin', 'article', 'category', ''), ('2', '22', 'admin', 'article', 'categoryadd', ''), ('2', '23', 'admin', 'article', 'categoryedit', ''), ('2', '24', 'admin', 'article', 'categorydelete', ''), ('2', '25', 'admin', 'article', 'categorycache', ''), ('2', '40', 'admin', 'email', '', ''), ('2', '41', 'admin', 'email', '', ''), ('2', '42', 'admin', 'email', 'index', ''), ('2', '3', 'admin', 'system', '', ''), ('2', '4', 'admin', 'system', '', ''), ('2', '17', 'admin', 'system', 'adminmanage', ''), ('2', '26', 'admin', 'system', 'adminadd', ''), ('2', '27', 'admin', 'system', 'adminedit', ''), ('2', '28', 'admin', 'system', 'adminresetpassword', ''), ('2', '29', 'admin', 'system', 'admindelete', ''), ('2', '7', 'admin', 'system', 'adminrolelist', ''), ('2', '30', 'admin', 'system', 'adminroleadd', ''), ('2', '31', 'admin', 'system', 'adminroleforbid', ''), ('2', '32', 'admin', 'system', 'adminprivsetting', ''), ('2', '33', 'admin', 'system', 'adminroleedit', ''), ('2', '34', 'admin', 'system', 'adminroledelete', ''), ('2', '5', 'admin', 'system', '', ''), ('2', '8', 'admin', 'system', 'adminnodelists', ''), ('2', '14', 'admin', 'system', 'adminnodeadd', ''), ('2', '15', 'admin', 'syetem', 'adminnodeedit', ''), ('2', '16', 'admin', 'system', 'adminnodedelete', ''), ('2', '50', 'admin', 'system', 'adminnodelistsnew', '');
COMMIT;

-- ----------------------------
--  Table structure for `db_admin_times`
-- ----------------------------
DROP TABLE IF EXISTS `db_admin_times`;
CREATE TABLE `db_admin_times` (
  `username` char(40) NOT NULL,
  `ip` char(15) NOT NULL,
  `logintime` int(10) unsigned NOT NULL DEFAULT '0',
  `isadmin` tinyint(1) NOT NULL DEFAULT '0',
  `times` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`,`isadmin`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='用户登录错误次数表';

-- ----------------------------
--  Table structure for `db_article`
-- ----------------------------
DROP TABLE IF EXISTS `db_article`;
CREATE TABLE `db_article` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(10) unsigned DEFAULT '0' COMMENT '一级分类',
  `url` char(255) DEFAULT NULL COMMENT 'url地址',
  `title` varchar(64) DEFAULT NULL,
  `img` varchar(128) DEFAULT NULL,
  `thumb` varchar(128) DEFAULT NULL COMMENT '缩略图',
  `keywords` char(40) DEFAULT NULL COMMENT '关键字',
  `description` varchar(255) DEFAULT NULL COMMENT '文章描述',
  `views` int(10) unsigned DEFAULT '0',
  `status` tinyint(2) DEFAULT '0' COMMENT '文章状态',
  `username` char(20) DEFAULT NULL COMMENT '发布人',
  `inputtime` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `code` varchar(10) DEFAULT NULL,
  `pushed` tinyint(1) DEFAULT '0',
  `spider_count` smallint(8) unsigned zerofill DEFAULT '00000000',
  PRIMARY KEY (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章表';

-- ----------------------------
--  Table structure for `db_article_category`
-- ----------------------------
DROP TABLE IF EXISTS `db_article_category`;
CREATE TABLE `db_article_category` (
  `catid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `module` varchar(15) DEFAULT NULL,
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `parentid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `arrparentid` varchar(255) NOT NULL DEFAULT '0',
  `child` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `arrchildid` mediumtext,
  `catname` varchar(30) NOT NULL DEFAULT '',
  `style` varchar(5) DEFAULT '',
  `image` varchar(100) DEFAULT '',
  `description` mediumtext,
  `parentdir` varchar(100) NOT NULL DEFAULT '',
  `catdir` varchar(30) NOT NULL DEFAULT '',
  `url` varchar(100) DEFAULT '',
  `items` mediumint(8) unsigned DEFAULT '0',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `setting` mediumtext,
  `listorder` smallint(5) unsigned DEFAULT '0',
  `ismenu` tinyint(1) unsigned DEFAULT '1',
  `sethtml` tinyint(1) unsigned DEFAULT '0',
  `letter` varchar(30) DEFAULT '',
  `cron` tinyint(1) DEFAULT '0',
  `last_cron_time` int(10) DEFAULT '0',
  `next_cron_time` int(10) DEFAULT '0',
  PRIMARY KEY (`catid`),
  KEY `module` (`module`,`parentid`,`listorder`,`catid`),
  KEY `siteid` (`siteid`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章分类表';

-- ----------------------------
--  Records of `db_article_category`
-- ----------------------------
BEGIN;
INSERT INTO `db_article_category` VALUES ('1', '0', null, '0', '0', '0', '0', '0', '1', '内部', '', '', null, '', '', '', '0', '0', 'a:6:{s:17:\"category_template\";s:0:\"\";s:13:\"list_template\";s:0:\"\";s:13:\"show_template\";s:0:\"\";s:10:\"meta_title\";s:0:\"\";s:13:\"meta_keywords\";s:0:\"\";s:16:\"meta_description\";s:0:\"\";}', '1', '1', '0', '', '0', '0', '0'), ('2', '0', null, '0', '0', '0', '0', '0', '2', 'neibu 2', '', '', null, '', '', '', '0', '0', 'a:6:{s:17:\"category_template\";s:0:\"\";s:13:\"list_template\";s:0:\"\";s:13:\"show_template\";s:0:\"\";s:10:\"meta_title\";s:0:\"\";s:13:\"meta_keywords\";s:0:\"\";s:16:\"meta_description\";s:0:\"\";}', '2', '1', '0', '', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `db_article_data`
-- ----------------------------
DROP TABLE IF EXISTS `db_article_data`;
CREATE TABLE `db_article_data` (
  `article_id` int(11) DEFAULT NULL,
  `content` mediumtext,
  KEY `article` (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章内容表';

-- ----------------------------
--  Table structure for `db_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `db_attachment`;
CREATE TABLE `db_attachment` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` char(15) NOT NULL,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `viewhost` char(100) DEFAULT NULL,
  `savename` char(50) NOT NULL,
  `savepath` char(200) NOT NULL,
  `filename` char(50) NOT NULL,
  `filepath` char(200) NOT NULL,
  `filesize` int(10) unsigned NOT NULL DEFAULT '0',
  `fileext` char(10) NOT NULL,
  `isimage` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `isthumb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `downloads` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uploadtime` int(10) unsigned NOT NULL DEFAULT '0',
  `uploadip` char(15) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `authcode` char(32) NOT NULL,
  `siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `authcode` (`authcode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='附件表';

-- ----------------------------
--  Table structure for `db_page`
-- ----------------------------
DROP TABLE IF EXISTS `db_page`;
CREATE TABLE `db_page` (
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(160) NOT NULL,
  `style` varchar(24) DEFAULT '',
  `keywords` varchar(40) DEFAULT '',
  `content` text,
  `template` varchar(30) DEFAULT '',
  `updatetime` int(10) unsigned DEFAULT '0',
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='单页表';

-- ----------------------------
--  Table structure for `db_search`
-- ----------------------------
DROP TABLE IF EXISTS `db_search`;
CREATE TABLE `db_search` (
  `searchid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `model` varchar(50) NOT NULL DEFAULT '0',
  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `adddate` int(10) unsigned NOT NULL,
  `data` text NOT NULL,
  `siteid` smallint(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`searchid`),
  FULLTEXT KEY `data` (`data`)
) ENGINE=MyISAM AUTO_INCREMENT=3182 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='搜索表';

SET FOREIGN_KEY_CHECKS = 1;
